SHOW-CREATE-DATABASE
SHOW-CREATE-DATABASE
Name
SHOW CREATE DATABASE
Description
This statement is used to check the creation of the doris database.
Syntax:
SHOW CREATE DATABASE db_name;
Note:
db_name: The name of the database exists in doris.
Example
View the creation of the test database in doris
mysql> SHOW CREATE DATABASE test;
+----------+----------------------------+
| Database | Create Database |
+----------+----------------------------+
| test | CREATE DATABASE `test` |
+----------+----------------------------+
1 row in set (0.00 sec)
Keywords
SHOW, CREATE, DATABASE
